The Experts Voice in SQL Server - Rodrigues F., Coles M., and Dye D. / Родригес Ф., Колес М., Дай Д. - Pro SQL Server 2012 Integration Services / SQL Server 2012 Integration Services для профессионалов

The Experts Voice in SQL Server - Rodrigues F., Coles M., and Dye D. / Родригес Ф., Колес М., Дай Д. - Pro SQL Server 2012 Integration Services / SQL Server 2012 Integration Services для профессионалов Pro SQL Server 2012 Integration Services

Год: 2012
Автор: Rodrigues F., Coles M., and Dye D.
Издательство: Apress
ISBN: 978-1-4302-3694-8
Серия: The Expert's Voice in SQL Server
Язык: Английский
Формат: PDF/EPUP
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 617 xviii
Описание: Книга по использованию последней версии SSIS (средство для конвертации и трансформации данных из различных систем управления базами данных в SQL Server).
Описание на английском: Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source.
Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers.
Helps you design and develop robust, efficient, scalable ETL solutions
Walks you through using the built-in, stock components
Shows how to programmatically extend the power of SSIS to cover any possible scenario
What you’ll learn
Create an SSIS package from scratch
Deploy an SSIS package to any environment
Benchmark the performance of SSIS packages using common tools
Optimize SSIS data flows to achieve maximum performance
Use .NET to extend the power of the stock SSIS toolkit
Profile and scrub data during the ETL process

Примеры страниц

Оглавление
About the Authors xvii
About the Technical Reviewer xviii
Chapter 1: Introducing Integration Services 1
Chapter 2: BIDS and SSMS 11
Chapter 3: Hello World-Your First SSIS 2012 Package 43
Chapter 4: Connection Managers 83
Chapter 5: Control Flow Basics 107
Chapter 6: Advanced Control Flow Tasks 163
Chapter 7: Source and Destination Adapters 203
Chapter 8: Data Flow Transformations 245
Chapter 9: Variables, Parameters, and Expressions 325
Chapter 10: Scripting 361
Chapter 11: Events and Error Handling 405
Chapter 12: Data Profiling and Scrubbing 427
Chapter 13: Logging and Auditing 465
Chapter 14: Heterogeneous Sources and Destinations 487
Chapter 15: Data Flow Tuning and Optimization 511
Chapter 16: Parent-Child Design Pattern 525
Chapter 17: Dimensional Data ETL 543
Chapter 18: Building Robust Solutions 561
Chapter 19: Deployment Model 579
Index 605